<!doctype html>
<html class="no-js" lang="en">
<head>
    <meta name="viewport" content="width=device-width, initial-scale=1" charset="UTF-8">
    <title>StatementBuilder</title>
<link href="../../../images/logo-icon.svg" rel="icon" type="image/svg"><script>var pathToRoot = "../../../";</script>
    <script>document.documentElement.classList.replace("no-js", "js");</script>
    <script>const storage = localStorage.getItem("dokka-dark-mode")
      if (storage == null) {
        const osDarkSchemePreferred = window.matchMedia && window.matchMedia('(prefers-color-scheme: dark)').matches
        if (osDarkSchemePreferred === true) {
          document.getElementsByTagName("html")[0].classList.add("theme-dark")
        }
      } else {
        const savedDarkMode = JSON.parse(storage)
        if (savedDarkMode === true) {
          document.getElementsByTagName("html")[0].classList.add("theme-dark")
        }
      }
    </script>
<script type="text/javascript" src="https://unpkg.com/kotlin-playground@1/dist/playground.min.js" async></script>
<script type="text/javascript" src="../../../scripts/sourceset_dependencies.js" async></script>
<link href="../../../styles/style.css" rel="Stylesheet">
<link href="../../../styles/main.css" rel="Stylesheet">
<link href="../../../styles/prism.css" rel="Stylesheet">
<link href="../../../styles/logo-styles.css" rel="Stylesheet">
<link href="../../../ui-kit/ui-kit.min.css" rel="Stylesheet">
<script type="text/javascript" src="../../../scripts/safe-local-storage_blocking.js"></script>
<script type="text/javascript" src="../../../scripts/navigation-loader.js" async></script>
<script type="text/javascript" src="../../../scripts/platform-content-handler.js" async></script>
<script type="text/javascript" src="../../../scripts/main.js" defer></script>
<script type="text/javascript" src="../../../scripts/prism.js" async></script>
<script type="text/javascript" src="../../../ui-kit/ui-kit.min.js" defer></script></head>
<body>
<div class="root">
    <header class="navigation theme-dark" id="navigation-wrapper" role="banner">
<a class="library-name--link" href="../../../index.html" tabindex="1">
                    exposed
            </a>        <button class="navigation-controls--btn navigation-controls--btn_toc ui-kit_mobile-only" id="toc-toggle" type="button">Toggle table of contents
        </button>
        <div class="navigation-controls--break ui-kit_mobile-only"></div>
        <div class="library-version" id="library-version">1.0.0-rc-4
        </div>
        <div class="navigation-controls">
        <ul class="filter-section filter-section_loading" id="filter-section" aria-label="Target filter">
                <button class="platform-tag platform-selector jvm-like" data-active="" aria-pressed="true" data-filter=":exposed-core/main">jvm</button>
            <div class="dropdown filter-section--dropdown" data-role="dropdown" id="filter-section-dropdown">
                <button class="button button_dropdown filter-section--dropdown-toggle" role="combobox" data-role="dropdown-toggle" aria-controls="platform-tags-listbox" aria-haspopup="listbox" aria-expanded="false" aria-label="Toggle source sets"></button>
                <ul role="listbox" id="platform-tags-listbox" class="dropdown--list" data-role="dropdown-listbox" aria-label="Target filter">
                    <div class="dropdown--header"><span>Target filter</span>
                        <button class="button" data-role="dropdown-toggle" aria-label="Close target filter">
                            <i class="ui-kit-icon ui-kit-icon_cross"></i>
                        </button>
                    </div>
                        <li role="option" class="dropdown--option platform-selector-option jvm-like" tabindex="0">
                            <label class="checkbox">
                                <input type="checkbox" class="checkbox--input" id=":exposed-core/main" data-filter=":exposed-core/main">
                                <span class="checkbox--icon"></span>
                                jvm
                            </label>
                        </li>
                </ul>
                <div class="dropdown--overlay"></div>
            </div>
        </ul>
            <button class="navigation-controls--btn navigation-controls--btn_theme" id="theme-toggle-button" type="button">Switch theme
            </button>
            <div class="navigation-controls--btn navigation-controls--btn_search" id="searchBar" role="button">Search in
                API
            </div>
        </div>
    </header>
    <div id="container">
        <nav id="leftColumn" class="sidebar" data-item-type="SECTION" data-item-config="{&quot;defaultSize&quot;: 280, &quot;minSize&quot;: 200, &quot;maxSize&quot;: 400}">
            <a class="toc--skip-link" href="#main">Skip to content</a>
            <div class="dropdown theme-dark_mobile" data-role="dropdown" id="toc-dropdown">
                <ul role="listbox" id="toc-listbox" class="dropdown--list dropdown--list_toc-list" data-role="dropdown-listbox" aria-label="Table of contents">
                    <div class="dropdown--header">
                            <span>
                                    exposed
                            </span>
                        <button class="button" data-role="dropdown-toggle" aria-label="Close table of contents">
                            <i class="ui-kit-icon ui-kit-icon_cross"></i>
                        </button>
                    </div>
                    <div class="sidebar--inner" id="sideMenu"></div>
                </ul>
                <div class="dropdown--overlay"></div>
            </div>
        </nav>
        <div id="resizer" class="resizer" data-item-type="BAR"></div>
        <div id="main" data-item-type="SECTION" role="main">
<div class="main-content" data-page-type="classlike" id="content" pageids="exposed-core::org.jetbrains.exposed.v1.core.statements/StatementBuilder///PointingToDeclaration//-1435837140">
  <div class="breadcrumbs"><a href="../../index.html">exposed-core</a><span class="delimiter">/</span><a href="../index.html">org.jetbrains.exposed.v1.core.statements</a><span class="delimiter">/</span><span class="current">StatementBuilder</span></div>
  <div class="cover ">
    <h1 class="cover"><span>Statement</span><wbr><span><span>Builder</span></span></h1>
    <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">interface </span><a href="index.html">StatementBuilder</a></div><p class="paragraph">Represents all the DSL methods available when building SQL statements.</p></div></div>
  </div>
  <div class="tabbedcontent">
    <div class="tabs-section" tabs-section="tabs-section"><button class="section-tab" data-active="" data-togglable="CONSTRUCTOR,TYPE,PROPERTY,FUNCTION">Members</button></div>
    <div class="tabs-section-body">
      <div data-togglable="FUNCTION">
        <h2 class="tableheader">Functions</h2>
        <div class="table"><a data-name="681503322%2FFunctions%2F-1435837140" anchor-label="batchInsert" id="681503322%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="batch-insert.html"><span>batch</span><wbr><span><span>Insert</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="681503322%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="batch-insert.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="batch-insert.html">E</a><span class="token operator">&gt; </span><a href="batch-insert.html">T</a><span class="token punctuation">.</span><a href="batch-insert.html"><span class="token function">batchInsert</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">ignoreErrors<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">false</span><span class="token punctuation">, </span></span><span class="parameter ">shouldReturnGeneratedValues<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">true</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../-batch-insert-statement/index.html">BatchInsertStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="batch-insert.html">E</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-batch-insert-statement/index.html">BatchInsertStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that batch inserts new rows into a table.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="720566733%2FFunctions%2F-1435837140" anchor-label="batchReplace" id="720566733%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="batch-replace.html"><span>batch</span><wbr><span><span>Replace</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="720566733%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="batch-replace.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="batch-replace.html">E</a><span class="token operator"> : </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-any/index.html">Any</a><span class="token operator">&gt; </span><a href="batch-replace.html">T</a><span class="token punctuation">.</span><a href="batch-replace.html"><span class="token function">batchReplace</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">shouldReturnGeneratedValues<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">true</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../-batch-replace-statement/index.html">BatchReplaceStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="batch-replace.html">E</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-batch-replace-statement/index.html">BatchReplaceStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that either batch inserts new rows into a table, or, if insertions violate unique constraints, first deletes the existing rows before inserting new rows.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="792962891%2FFunctions%2F-1435837140" anchor-label="batchUpsert" id="792962891%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="batch-upsert.html"><span>batch</span><wbr><span><span>Upsert</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="792962891%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="batch-upsert.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="batch-upsert.html">E</a><span class="token operator">&gt; </span><a href="batch-upsert.html">T</a><span class="token punctuation">.</span><a href="batch-upsert.html"><span class="token function">batchUpsert</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">onUpdateList<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-pair/index.html">Pair</a><span class="token operator">&lt;</span><a href="../../org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-any/index.html">Any</a><span class="token operator">?</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">onUpdate<span class="token operator">: </span><a href="../-upsert-builder/index.html">UpsertBuilder</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">onUpdateExclude<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">shouldReturnGeneratedValues<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">true</span><span class="token punctuation">, </span></span><span class="parameter "><span class="token keyword">vararg </span>keys<span class="token operator">: </span><a href="../../org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../-batch-upsert-statement/index.html">BatchUpsertStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="batch-upsert.html">E</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-batch-upsert-statement/index.html">BatchUpsertStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that either batch inserts new rows into a table, or updates the existing rows if insertions violate unique constraints.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="1221863498%2FFunctions%2F-1435837140" anchor-label="delete" id="1221863498%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="delete.html"><span><span>delete</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="1221863498%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><a href="../../org.jetbrains.exposed.v1.core/-join/index.html">Join</a><span class="token punctuation">.</span><a href="delete.html"><span class="token function">delete</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">targetTable<span class="token operator">: </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span></span><span class="parameter "><span class="token keyword">vararg </span>targetTables<span class="token operator">: </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span></span><span class="parameter ">ignore<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">false</span><span class="token punctuation">, </span></span><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null</span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-delete-statement/index.html">DeleteStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that deletes rows from a table in a join relation.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1823798313%2FFunctions%2F-1435837140" anchor-label="deleteAll" id="-1823798313%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="delete-all.html"><span>delete</span><wbr><span><span>All</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1823798313%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="delete-all.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="delete-all.html">T</a><span class="token punctuation">.</span><a href="delete-all.html"><span class="token function">deleteAll</span></a><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-delete-statement/index.html">DeleteStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that deletes all rows in a table.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="531165009%2FFunctions%2F-1435837140" anchor-label="deleteIgnoreWhere" id="531165009%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="delete-ignore-where.html"><span>delete</span><wbr><span>Ignore</span><wbr><span><span>Where</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="531165009%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="delete-ignore-where.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="delete-ignore-where.html">T</a><span class="token punctuation">.</span><a href="delete-ignore-where.html"><span class="token function">deleteIgnoreWhere</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">op<span class="token operator">: </span><a href="delete-ignore-where.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-delete-statement/index.html">DeleteStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that deletes only rows in a table that match the provided <a href="delete-ignore-where.html">op</a>, while ignoring any possible errors that occur during the process.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-419107653%2FFunctions%2F-1435837140" anchor-label="deleteReturning" id="-419107653%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="delete-returning.html"><span>delete</span><wbr><span><span>Returning</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-419107653%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="delete-returning.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="delete-returning.html">T</a><span class="token punctuation">.</span><a href="delete-returning.html"><span class="token function">deleteReturning</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">returning<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator"> = </span>columns<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null</span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-returning-statement/index.html">ReturningStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that deletes rows in a table and returns specified data from the deleted rows.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-333610685%2FFunctions%2F-1435837140" anchor-label="deleteWhere" id="-333610685%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="delete-where.html"><span>delete</span><wbr><span><span>Where</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-333610685%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="delete-where.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="delete-where.html">T</a><span class="token punctuation">.</span><a href="delete-where.html"><span class="token function">deleteWhere</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">op<span class="token operator">: </span><a href="delete-where.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-delete-statement/index.html">DeleteStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that deletes only rows in a table that match the provided <a href="delete-where.html">op</a>.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="1963031980%2FFunctions%2F-1435837140" anchor-label="insert" id="1963031980%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="insert.html"><span><span>insert</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="1963031980%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="insert.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="insert.html">T</a><span class="token punctuation">.</span><a href="insert.html"><span class="token function">insert</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">body<span class="token operator">: </span><a href="insert.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../-insert-statement/index.html">InsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-number/index.html">Number</a><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-insert-statement/index.html">InsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-number/index.html">Number</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that inserts a new row into a table.</p></div><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="insert.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="insert.html">T</a><span class="token punctuation">.</span><a href="insert.html"><span class="token function">insert</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">selectQuery<span class="token operator">: </span><a href="../../org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">columns<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null</span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-insert-select-statement/index.html">InsertSelectStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that uses data retrieved from a <a href="insert.html">selectQuery</a> to insert new rows into a table.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-802514660%2FFunctions%2F-1435837140" anchor-label="insertIgnore" id="-802514660%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="insert-ignore.html"><span>insert</span><wbr><span><span>Ignore</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-802514660%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="insert-ignore.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="insert-ignore.html">T</a><span class="token punctuation">.</span><a href="insert-ignore.html"><span class="token function">insertIgnore</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">body<span class="token operator">: </span><a href="insert-ignore.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../-update-builder/index.html">UpdateBuilder</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-insert-statement/index.html">InsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html">Long</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that inserts a new row into a table, while ignoring any possible errors that occur during the process.</p></div><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="insert-ignore.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="insert-ignore.html">T</a><span class="token punctuation">.</span><a href="insert-ignore.html"><span class="token function">insertIgnore</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">selectQuery<span class="token operator">: </span><a href="../../org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">columns<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null</span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-insert-select-statement/index.html">InsertSelectStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that uses data retrieved from a <a href="insert-ignore.html">selectQuery</a> to insert new rows into a table, while ignoring any possible errors that occur during the process.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-1709847019%2FFunctions%2F-1435837140" anchor-label="insertReturning" id="-1709847019%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="insert-returning.html"><span>insert</span><wbr><span><span>Returning</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-1709847019%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="insert-returning.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="insert-returning.html">T</a><span class="token punctuation">.</span><a href="insert-returning.html"><span class="token function">insertReturning</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">returning<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator"> = </span>columns<span class="token punctuation">, </span></span><span class="parameter ">ignoreErrors<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator"> = </span><span class="token boolean">false</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="insert-returning.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../-insert-statement/index.html">InsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-number/index.html">Number</a><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-returning-statement/index.html">ReturningStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that inserts new rows into a table and returns specified data from the inserted rows.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="1324247931%2FFunctions%2F-1435837140" anchor-label="mergeFrom" id="1324247931%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="merge-from.html"><span>merge</span><wbr><span><span>From</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="1324247931%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="merge-from.html">D</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token punctuation">, </span><a href="merge-from.html">S</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="merge-from.html">D</a><span class="token punctuation">.</span><a href="merge-from.html"><span class="token function">mergeFrom</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">source<span class="token operator">: </span><a href="merge-from.html">S</a><span class="token punctuation">, </span></span><span class="parameter ">on<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../-merge-table-statement/index.html">MergeTableStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-merge-table-statement/index.html">MergeTableStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that inserts, updates, or deletes records in a target table based on a comparison with a source table.</p></div><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="merge-from.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="merge-from.html">T</a><span class="token punctuation">.</span><a href="merge-from.html"><span class="token function">mergeFrom</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">selectQuery<span class="token operator">: </span><a href="../../org.jetbrains.exposed.v1.core/-query-alias/index.html">QueryAlias</a><span class="token punctuation">, </span></span><span class="parameter ">on<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="../-merge-select-statement/index.html">MergeSelectStatement</a><span class="token punctuation">.</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-merge-select-statement/index.html">MergeSelectStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that inserts, updates, or deletes records in a target table based on a comparison with a select query source.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-386603842%2FFunctions%2F-1435837140" anchor-label="replace" id="-386603842%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="replace.html"><span><span>replace</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-386603842%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="replace.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="replace.html">T</a><span class="token punctuation">.</span><a href="replace.html"><span class="token function">replace</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">body<span class="token operator">: </span><a href="replace.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../-update-builder/index.html">UpdateBuilder</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-replace-statement/index.html">ReplaceStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html">Long</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that either inserts a new row into a table, or, if insertion would violate a unique constraint, first deletes the existing row before inserting a new row.</p></div><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="replace.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="replace.html">T</a><span class="token punctuation">.</span><a href="replace.html"><span class="token function">replace</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">selectQuery<span class="token operator">: </span><a href="../../org.jetbrains.exposed.v1.core/-abstract-query/index.html">AbstractQuery</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">columns<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null</span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-replace-select-statement/index.html">ReplaceSelectStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that uses data retrieved from a <a href="replace.html">selectQuery</a> to either insert a new row into a table, or, if insertion would violate a unique constraint, first delete the existing row before inserting a new row.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="1058030171%2FFunctions%2F-1435837140" anchor-label="update" id="1058030171%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="update.html"><span><span>update</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="1058030171%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="update.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="update.html">T</a><span class="token punctuation">.</span><a href="update.html"><span class="token function">update</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="update.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-update-statement/index.html">UpdateStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that updates rows of a table.</p></div><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><a href="../../org.jetbrains.exposed.v1.core/-join/index.html">Join</a><span class="token punctuation">.</span><a href="update.html"><span class="token function">update</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">limit<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-int/index.html">Int</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><span class="token punctuation">(</span><a href="../-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-update-statement/index.html">UpdateStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that updates rows of a join relation.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="1528575942%2FFunctions%2F-1435837140" anchor-label="updateReturning" id="1528575942%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="update-returning.html"><span>update</span><wbr><span><span>Returning</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="1528575942%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="update-returning.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="update-returning.html">T</a><span class="token punctuation">.</span><a href="update-returning.html"><span class="token function">updateReturning</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter ">returning<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator"> = </span>columns<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="update-returning.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-returning-statement/index.html">ReturningStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that updates rows of a table and returns specified data from the updated rows.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-953750705%2FFunctions%2F-1435837140" anchor-label="upsert" id="-953750705%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="upsert.html"><span><span>upsert</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-953750705%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="upsert.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="upsert.html">T</a><span class="token punctuation">.</span><a href="upsert.html"><span class="token function">upsert</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter "><span class="token keyword">vararg </span>keys<span class="token operator">: </span><a href="../../org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">onUpdate<span class="token operator">: </span><a href="../-upsert-builder/index.html">UpsertBuilder</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">onUpdateExclude<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="upsert.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../-upsert-statement/index.html">UpsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html">Long</a><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-upsert-statement/index.html">UpsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html">Long</a><span class="token operator">&gt;</span></div><div class="brief "><p class="paragraph">Represents the SQL statement that either inserts a new row into a table, or updates the existing row if insertion would violate a unique constraint.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
<a data-name="-2100471830%2FFunctions%2F-1435837140" anchor-label="upsertReturning" id="-2100471830%2FFunctions%2F-1435837140" data-filterable-set=":exposed-core/main"></a>
          <div class="table-row table-row_content" data-filterable-current=":exposed-core/main" data-filterable-set=":exposed-core/main">
            <div class="main-subrow keyValue ">
              <div class=""><span class="inline-flex">
                  <div><a href="upsert-returning.html"><span>upsert</span><wbr><span><span>Returning</span></span></a></div>
<span class="anchor-wrapper"><span class="anchor-icon" pointing-to="-2100471830%2FFunctions%2F-1435837140"></span>
                    <div class="copy-popup-wrapper "><span class="copy-popup-icon"></span><span>Link copied to clipboard</span></div>
                  </span></span></div>
              <div>
                <div class="title">
                  <div class="platform-hinted " data-platform-hinted="data-platform-hinted"><div class="content sourceset-dependent-content" data-active="" data-togglable=":exposed-core/main"><div class="symbol monospace"><span class="token keyword">open </span><span class="token keyword">fun </span><span class="token operator">&lt;</span><a href="upsert-returning.html">T</a><span class="token operator"> : </span><a href="../../org.jetbrains.exposed.v1.core/-table/index.html">Table</a><span class="token operator">&gt; </span><a href="upsert-returning.html">T</a><span class="token punctuation">.</span><a href="upsert-returning.html"><span class="token function">upsertReturning</span></a><span class="token punctuation">(</span><span class="parameters "><span class="parameter "><span class="token keyword">vararg </span>keys<span class="token operator">: </span><a href="../../org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token punctuation">, </span></span><span class="parameter ">returning<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../org.jetbrains.exposed.v1.core/-expression/index.html">Expression</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator"> = </span>columns<span class="token punctuation">, </span></span><span class="parameter ">onUpdate<span class="token operator">: </span><a href="../-upsert-builder/index.html">UpsertBuilder</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../-update-statement/index.html">UpdateStatement</a><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">onUpdateExclude<span class="token operator">: </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin.collections/-list/index.html">List</a><span class="token operator">&lt;</span><a href="../../org.jetbrains.exposed.v1.core/-column/index.html">Column</a><span class="token operator">&lt;</span><span class="token operator">*</span><span class="token operator">&gt;</span><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">where<span class="token operator">: </span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="../../org.jetbrains.exposed.v1.core/-op/index.html">Op</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-boolean/index.html">Boolean</a><span class="token operator">&gt;</span><span class="token operator">?</span><span class="token operator"> = </span>null<span class="token punctuation">, </span></span><span class="parameter ">body<span class="token operator">: </span><a href="upsert-returning.html">T</a><span class="token punctuation">.</span><span class="token punctuation">(</span><a href="../-upsert-statement/index.html">UpsertStatement</a><span class="token operator">&lt;</span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-long/index.html">Long</a><span class="token operator">&gt;</span><span class="token punctuation">)</span><span class="token operator"> -&gt; </span><a href="https://kotlinlang.org/api/core/kotlin-stdlib/kotlin/-unit/index.html">Unit</a></span></span><span class="token punctuation">)</span><span class="token operator">: </span><a href="../-returning-statement/index.html">ReturningStatement</a></div><div class="brief "><p class="paragraph">Represents the SQL statement that either inserts a new row into a table, or updates the existing row if insertion would violate a unique constraint, and also returns specified data from the modified rows.</p></div></div></div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>
    <div class="footer">
        <div class="footer--container">
            <a href="#content" id="go-to-top-link" class="footer--button footer--button_go-to-top"></a>
            <div class="footer--content">
                <div>
                    <span>Generated by </span>
                    <a class="footer--link footer--link_external" href="https://github.com/Kotlin/dokka">
                        Dokka
                    </a>
                    <div>© 2025 Copyright</div>
                </div>
            </div>
        </div>
    </div>
        </div>
    </div>
</div>
</body>
</html>